SQL Interview Questions and Answers
Test your skills through the online practice test: SQL Quiz Online Practice Test
Ques 86. What is the value of comm and sal after executing the following query if the initial value of 'sal' is 10000 UPDATE EMP SET SAL = SAL + 1000, COMM = SAL*0.1;?
sal = 11000, comm = 1000.
Is it helpful?
Add Comment
View Comments
Ques 87. Which command displays the SQL command in the SQL buffer, and then executes it?
RUN.
Is it helpful?
Add Comment
View Comments
Ques 88. What command is used to get back the privileges offered by the GRANT command?
REVOKE.
Is it helpful?
Add Comment
View Comments
Ques 89. What will be the output of the following query?
SELECT DECODE(TRANSLATE('A','1234567890','1111111111'), '1','YES', 'NO' );?
NO.
Explanation : The query checks whether a given string is a numerical digit.
Is it helpful?
Add Comment
View Comments
Ques 90. Which date function is used to find the difference between two dates?
MONTHS_BETWEEN.
Is it helpful?
Add Comment
View Comments
Most helpful rated by users: